Read Row
Command Prototype
arrayRet = Excel.ReadRow(objExcelWorkBook,sheet,strCell)
Command Description
Read rows after the specified cell (inclusive) and return an array
Parameter Description
- Required Parameter
- objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel))
- sheet--If a string is used, it refers to the name of the specified sheet; if a number is used, it refers to the index of the specified sheet (starting from 0)
- strCell--The specified cell, supports two forms: cell names (such as "A1") or array of rows and columns (such as [row number, column number]). When using cell names, it is case insensitive
- return
- arrayRet--The variable used to save the output of the function call